1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="milkdairyDataSet" targetNamespace="http://tempuri.org/milkdairyDataSet.xsd" xmlns:mstns="http://tempuri.org/milkdairyDataSet.xsd" xmlns="http://tempuri.org/milkdairyDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="milkdairyConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="milkdairyConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MilkDairyManagementSystemCSharp.Properties.Settings.GlobalReference.Default.milkdairyConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dairyTableAdapter" GeneratorDataComponentClassName="dairyTableAdapter" Name="dairy" UserDataComponentName="dairyTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="milkdairyConnectionString (Settings)" DbObjectName="dbo.dairy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM [dbo].[dairy] WHERE (([Id] = @Original_Id) AND ((@IsNull_acnt_no = 1 AND [acnt_no] IS NULL) OR ([acnt_no] = @Original_acnt_no)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_d_no = 1 AND [d_no] IS NULL) OR ([d_no] = @Original_d_no)) AND ((@IsNull_liter = 1 AND [liter] IS NULL) OR ([liter] = @Original_liter)) AND ((@IsNull_fate = 1 AND [fate] IS NULL) OR ([fate] = @Original_fate)) AND ((@IsNull_pperl = 1 AND [pperl] IS NULL) OR ([pperl] = @Original_pperl)) AND ((@IsNull_total = 1 AND [total] IS NULL) OR ([total] = @Original_total)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acnt_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_acnt_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_d_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="true" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_d_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_liter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="true" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_liter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="false" SourceVersion="Original" />
28 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="true" SourceVersion="Original" />
29 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="false" SourceVersion="Original" />
30 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pperl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="true" SourceVersion="Original" />
31 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pperl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="false" SourceVersion="Original" />
32 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="true" SourceVersion="Original" />
33 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Original" />
34 </Parameters>
35 </DbCommand>
36 </DeleteCommand>
37 <InsertCommand>
38 <DbCommand CommandType="Text" ModifiedByUser="false">
39 <CommandText>INSERT INTO [dbo].[dairy] ([acnt_no], [name], [addr], [d_no], [liter], [fate], [pperl], [total]) VALUES (@acnt_no, @name, @addr, @d_no, @liter, @fate, @pperl, @total);
40 SELECT Id, acnt_no, name, addr, d_no, liter, fate, pperl, total FROM dairy WHERE (Id = SCOPE_IDENTITY())</CommandText>
41 <Parameters>
42 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@acnt_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="false" SourceVersion="Current" />
43 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
44 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
45 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@d_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="false" SourceVersion="Current" />
46 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@liter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="false" SourceVersion="Current" />
47 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="false" SourceVersion="Current" />
48 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pperl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="false" SourceVersion="Current" />
49 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Current" />
50 </Parameters>
51 </DbCommand>
52 </InsertCommand>
53 <SelectCommand>
54 <DbCommand CommandType="Text" ModifiedByUser="false">
55 <CommandText>SELECT Id, acnt_no, name, addr, d_no, liter, fate, pperl, total FROM dbo.dairy</CommandText>
56 <Parameters />
57 </DbCommand>
58 </SelectCommand>
59 <UpdateCommand>
60 <DbCommand CommandType="Text" ModifiedByUser="false">
61 <CommandText>UPDATE [dbo].[dairy] SET [acnt_no] = @acnt_no, [name] = @name, [addr] = @addr, [d_no] = @d_no, [liter] = @liter, [fate] = @fate, [pperl] = @pperl, [total] = @total WHERE (([Id] = @Original_Id) AND ((@IsNull_acnt_no = 1 AND [acnt_no] IS NULL) OR ([acnt_no] = @Original_acnt_no)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_d_no = 1 AND [d_no] IS NULL) OR ([d_no] = @Original_d_no)) AND ((@IsNull_liter = 1 AND [liter] IS NULL) OR ([liter] = @Original_liter)) AND ((@IsNull_fate = 1 AND [fate] IS NULL) OR ([fate] = @Original_fate)) AND ((@IsNull_pperl = 1 AND [pperl] IS NULL) OR ([pperl] = @Original_pperl)) AND ((@IsNull_total = 1 AND [total] IS NULL) OR ([total] = @Original_total)));
62 SELECT Id, acnt_no, name, addr, d_no, liter, fate, pperl, total FROM dairy WHERE (Id = @Id)</CommandText>
63 <Parameters>
64 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@acnt_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="false" SourceVersion="Current" />
65 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
66 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Current" />
67 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@d_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="false" SourceVersion="Current" />
68 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@liter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="false" SourceVersion="Current" />
69 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="false" SourceVersion="Current" />
70 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pperl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="false" SourceVersion="Current" />
71 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Current" />
72 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
73 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_acnt_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="true" SourceVersion="Original" />
74 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_acnt_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="acnt_no" SourceColumnNullMapping="false" SourceVersion="Original" />
75 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
76 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
77 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="true" SourceVersion="Original" />
78 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addr" SourceColumnNullMapping="false" SourceVersion="Original" />
79 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_d_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="true" SourceVersion="Original" />
80 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_d_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="d_no" SourceColumnNullMapping="false" SourceVersion="Original" />
81 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_liter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="true" SourceVersion="Original" />
82 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_liter" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="liter" SourceColumnNullMapping="false" SourceVersion="Original" />
83 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="true" SourceVersion="Original" />
84 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fate" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fate" SourceColumnNullMapping="false" SourceVersion="Original" />
85 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pperl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="true" SourceVersion="Original" />
86 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pperl" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pperl" SourceColumnNullMapping="false" SourceVersion="Original" />
87 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_total" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="true" SourceVersion="Original" />
88 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_total" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="total" SourceColumnNullMapping="false" SourceVersion="Original" />
89 <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[7B85E66E5B47A16D9E4F6DAC01C44393_DIO 2015\PROJECTS\MILKDAIRYMANAGEMENTSYSTEMCSHARP\MILKDAIRYMANAGEMENTSYSTEMCSHARP\MILKDAIRY.MDF].dbo.dairy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
90 </Parameters>
91 </DbCommand>
92 </UpdateCommand>
93 </DbSource>
94 </MainSource>
95 <Mappings>
96 <Mapping SourceColumn="Id" DataSetColumn="Id" />
97 <Mapping SourceColumn="acnt_no" DataSetColumn="acnt_no" />
98 <Mapping SourceColumn="name" DataSetColumn="name" />
99 <Mapping SourceColumn="addr" DataSetColumn="addr" />
100 <Mapping SourceColumn="d_no" DataSetColumn="d_no" />
101 <Mapping SourceColumn="liter" DataSetColumn="liter" />
102 <Mapping SourceColumn="fate" DataSetColumn="fate" />
103 <Mapping SourceColumn="pperl" DataSetColumn="pperl" />
104 <Mapping SourceColumn="total" DataSetColumn="total" />
105 </Mappings>
106 <Sources />
107 </TableAdapter>
108 </Tables>
109 <Sources />
110 </DataSource>
111 </xs:appinfo>
112 </xs:annotation>
113 <xs:element name="milkdairyDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="milkdairyDataSet" msprop:Generator_UserDSName="milkdairyDataSet">
114 <xs:complexType>
115 <xs:choice minOccurs="0" maxOccurs="unbounded">
116 <xs:element name="dairy" msprop:Generator_TableClassName="dairyDataTable" msprop:Generator_TableVarName="tabledairy" msprop:Generator_TablePropName="dairy" msprop:Generator_RowDeletingName="dairyRowDeleting" msprop:Generator_RowChangingName="dairyRowChanging" msprop:Generator_RowEvHandlerName="dairyRowChangeEventHandler" msprop:Generator_RowDeletedName="dairyRowDeleted" msprop:Generator_UserTableName="dairy" msprop:Generator_RowChangedName="dairyRowChanged" msprop:Generator_RowEvArgName="dairyRowChangeEvent" msprop:Generator_RowClassName="dairyRow">
117 <xs:complexType>
118 <xs:sequence>
119 <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
120 <xs:element name="acnt_no" msprop:Generator_ColumnVarNameInTable="columnacnt_no" msprop:Generator_ColumnPropNameInRow="acnt_no" msprop:Generator_ColumnPropNameInTable="acnt_noColumn" msprop:Generator_UserColumnName="acnt_no" minOccurs="0">
121 <xs:simpleType>
122 <xs:restriction base="xs:string">
123 <xs:maxLength value="50" />
124 </xs:restriction>
125 </xs:simpleType>
126 </xs:element>
127 <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
128 <xs:simpleType>
129 <xs:restriction base="xs:string">
130 <xs:maxLength value="50" />
131 </xs:restriction>
132 </xs:simpleType>
133 </xs:element>
134 <xs:element name="addr" msprop:Generator_ColumnVarNameInTable="columnaddr" msprop:Generator_ColumnPropNameInRow="addr" msprop:Generator_ColumnPropNameInTable="addrColumn" msprop:Generator_UserColumnName="addr" minOccurs="0">
135 <xs:simpleType>
136 <xs:restriction base="xs:string">
137 <xs:maxLength value="50" />
138 </xs:restriction>
139 </xs:simpleType>
140 </xs:element>
141 <xs:element name="d_no" msprop:Generator_ColumnVarNameInTable="columnd_no" msprop:Generator_ColumnPropNameInRow="d_no" msprop:Generator_ColumnPropNameInTable="d_noColumn" msprop:Generator_UserColumnName="d_no" minOccurs="0">
142 <xs:simpleType>
143 <xs:restriction base="xs:string">
144 <xs:maxLength value="50" />
145 </xs:restriction>
146 </xs:simpleType>
147 </xs:element>
148 <xs:element name="liter" msprop:Generator_ColumnVarNameInTable="columnliter" msprop:Generator_ColumnPropNameInRow="liter" msprop:Generator_ColumnPropNameInTable="literColumn" msprop:Generator_UserColumnName="liter" minOccurs="0">
149 <xs:simpleType>
150 <xs:restriction base="xs:string">
151 <xs:maxLength value="50" />
152 </xs:restriction>
153 </xs:simpleType>
154 </xs:element>
155 <xs:element name="fate" msprop:Generator_ColumnVarNameInTable="columnfate" msprop:Generator_ColumnPropNameInRow="fate" msprop:Generator_ColumnPropNameInTable="fateColumn" msprop:Generator_UserColumnName="fate" minOccurs="0">
156 <xs:simpleType>
157 <xs:restriction base="xs:string">
158 <xs:maxLength value="50" />
159 </xs:restriction>
160 </xs:simpleType>
161 </xs:element>
162 <xs:element name="pperl" msprop:Generator_ColumnVarNameInTable="columnpperl" msprop:Generator_ColumnPropNameInRow="pperl" msprop:Generator_ColumnPropNameInTable="pperlColumn" msprop:Generator_UserColumnName="pperl" minOccurs="0">
163 <xs:simpleType>
164 <xs:restriction base="xs:string">
165 <xs:maxLength value="50" />
166 </xs:restriction>
167 </xs:simpleType>
168 </xs:element>
169 <xs:element name="total" msprop:Generator_ColumnVarNameInTable="columntotal" msprop:Generator_ColumnPropNameInRow="total" msprop:Generator_ColumnPropNameInTable="totalColumn" msprop:Generator_UserColumnName="total" minOccurs="0">
170 <xs:simpleType>
171 <xs:restriction base="xs:string">
172 <xs:maxLength value="50" />
173 </xs:restriction>
174 </xs:simpleType>
175 </xs:element>
176 </xs:sequence>
177 </xs:complexType>
178 </xs:element>
179 </xs:choice>
180 </xs:complexType>
181 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
182 <xs:selector xpath=".//mstns:dairy" />
183 <xs:field xpath="mstns:Id" />
184 </xs:unique>
185 </xs:element>
186 </xs:schema>